Exporting aggregated and un-aggregated data

ABSTRACT

A computer-implemented method, which comprises the following: receiving a graphical selection of a subset of data points from a set of data points, each data point representing at least one record of a dimensionally-modeled fact collection; and exporting information associated with the selected subset of data points.

BACKGROUND OF THE INVENTION

1. Field of the Invention

The present invention relates to exporting a subset of multi-dimensionalrecords from a dataset, where the dataset represents adimensionally-modeled fact collection. More specifically, the presentinvention relates to causing one or more multi-dimensional records to begraphically selected, and exporting the selected multi-dimensionalrecords either in aggregated or in un-aggregated or raw form.

2. Background of the Invention

When interacting with and/or analyzing large datasets, where, forexample, each dataset may contain a million or more multi-dimensionalrecords, it can be difficult, impractical, and even impossible for usersto consider the entire datasets all at once. Instead, users often preferto focus on smaller subsets of records. Sometimes, users may select asubset of records that are related to a particular analysis from a largedataset. Other times, users may wish to distinguish normal records fromanomalous or erroneous ones.

One way for users to select a subset of records of particular interestfrom a large dataset is to display all the multi-dimensional recordsfrom the dataset textually, such as in a spread sheet, and then selectthose records of interest manually. However, this process may be verytedious and time consuming. In fact, it may be impractical and evenimpossible to display a million or more multi-dimensional recordstextually. And even if such large number of records could be displayedtextually, it would be almost impossible for users to go through theentire dataset in order to locate and select those records of particularinterest in any reasonable amount of time. In addition, understandingthe inter-relationships of these records, such as determining whichrecords are related to each other for a particular type of analysis, maybe very difficult when the records are displayed textually.

Accordingly, what are needed are systems and methods to address theabove-identified problems.

SUMMARY OF THE INVENTION

Broadly speaking, the present invention relates to exporting a selectedsubset of multi-dimensional records from a dataset in aggregated and/orun-aggregated form, where the dataset represents a dimensionally-modeledfact collection.

In one embodiment, a computer-implemented method is provided, whichcomprises the following: receiving a graphical selection of a subset ofdata points from a set of data points, each data point representing atleast one record of a dimensionally-modeled fact collection; andexporting information associated with the selected subset of datapoints. The term “export” as used here means any method ofdistinguishing the selected records from the unselected records.

In another embodiment, a computer-implemented method is provided, whichcomprises the following: receiving a graphical selection of a subset ofdata points from a set of data points, each data point representing atleast one record of a dimensionally-modeled fact collection; receivingan aggregation specification; aggregating a subset of recordscorresponding to the selected subset of data points in accordance withthe aggregation specification; and exporting the subset of records inaggregated form.

In yet another embodiment, a computer-implemented method is provided,which comprises the following: receiving a graphical selection of asubset of data points from a set of data points, each data pointrepresenting at least one record of a dimensionally-modeled factcollection; and exporting a subset of records corresponding to theselected subset of data points in un-aggregated form.

These and other features, aspects, and advantages of the invention willbe described in more detail below in the detailed description and inconjunction with the following figures.

BRIEF DESCRIPTION OF THE DRAWINGS

The present invention is illustrated by way of example, and not by wayof limitation, in the figures of the accompanying drawings and in whichlike reference numerals refer to similar elements and in which:

FIG. 1 is a flowchart of a method that enables a user to cause a subsetof multi-dimensional records to be exported.

FIG. 2A illustrates a dataset graphically represented using a scatterplot.

FIG. 2B illustrates the dataset shown in FIG. 2A with a selected subsetof data points, where each data point represents at least onemulti-dimensional record from the dataset.

FIG. 3 illustrates a sample user interface that enables users to specifyaggregation specification and exporting form.

FIG. 4 is a simplified diagram of a network environment in whichspecific embodiments of the present invention may be implemented.

DETAILED DESCRIPTION OF THE INVENTION

The present invention will now be described in detail with reference toa few preferred embodiments thereof as illustrated in the accompanyingdrawings. In the following description, numerous specific details areset forth in order to provide a thorough understanding of the presentinvention. It will be apparent, however, to one skilled in the art, thatthe present invention may be practiced without some or all of thesespecific details. In other instances, well known process steps and/orstructures have not been described in detail in order to notunnecessarily obscure the present invention. In addition, while theinvention will be described in conjunction with the particularembodiments, it will be understood that it is not intended to limit theinvention to the described embodiments. To the contrary, it is intendedto cover alternatives, modifications, and equivalents as may be includedwithin the spirit and scope of the invention as defined by the appendedclaims.

Businesses and other types of institutions or entities often collectfactual-based data for various purposes, such as analyzing markettrends, planning for business growth, conducting targetedadvertisements, etc. For example, a business may collect various typesof information about its customers, such as the customers' age, gender,spending habit, buying power, preferred products, etc. Alternatively, abusiness may collect factual data about individual businesstransactions. Often, the amount of factual data collected may be quitelarge. It is not unusual for a large dataset to contain one million ormore multi-dimensional records, where each record represents a customer,a business transaction, an entity, etc. Each record may comprisemultiple data values, where each data value represents a particularpiece of factual information within the record.

For ease of use, the records in a dataset may be organized as, orotherwise accessible, according to a dimensional data model, such as atable. The following is a sample representation of such a table.

TABLE 1 Customer Geographical Annual Monthly ID Age Gender LocationIncome Spending A 31 M CA  $75,000 $1,200 B 45 F CA $110,000 $2,000 C 27F NY  $65,000 $1,500 D 18 M WA  $32,000 $1,300 E 55 F CO  $50,000 $2,200

In the example shown in Table 1, each row of the table represents asingle record, and in this case, each record represents a customer,identified by a unique customer ID (as shown in the first column).Alternatively in another example, each record/row may be a businesstransaction or an entity. Each column of the table represents adifferent dimension of the records, such as a category or a type of data(e.g., age, gender, monthly income, etc.). Inside the cells of the tableare the specific data values, each value representing a particular pieceof factual information about the corresponding record (e.g., customer ortransaction) in a corresponding dimension (e.g., category orcharacteristic), and a data value may either be a text, a number, or acombination of both. For example, the first row of Table 1 describes acustomer whose customer ID is “A.” Customer “A” is aged 31, a male,located in California, and has an annual income of $75,000 and a monthlyspending amount of $1,200. The entire table is a collection of facts,and such collection of facts may be referred to as adimensionally-modeled fact collection.

When working with large datasets, where, for example, each dataset maycomprise a million or more such multi-dimensional records, it may beimpractical, even impossible, to display all the multi-dimensionalrecords textually. Instead, it can be more convenient to represent therecords graphically using various graphical formats depending on userpreferences. For example, a scatter plot may be used to graphicallyrepresent the records shown in Table 1, with each axis representing aparticular dimension (column) and each data point representing at leastone record (row). Users may then interact with the data points in thescatter plot graphically (e.g., using a mouse or other method tointeract with the graphical display), such as selecting a subset of datapoints of particular interest, which, in effect, causes thecorresponding records represented by these data points to be selected.Furthermore, representing the records graphically may enable the usersto quickly identify related records, anomalous records, or records ofparticular interest, so that users may quickly select a subset ofrecords for further analysis.

The inventors have realized that it would be useful to enable the usersto easily and quickly identify or select graphically displayed datapoints of interest from a large master dataset. Thereafter, the recordsrepresented by the selected data points may be exported in eitheraggregated or un-aggregated format for further analysis.

FIG. 1 is a flowchart of a method that enables a user to cause a subsetof multi-dimensional records to be exported. At 100, one or moremulti-dimensional records contained in a large dataset are graphicallyrepresented. The actual graphical format used to represent the recordsmay vary depending on user preferences. The graphical representation mayhelp the users to easily and quickly determine the inter-relationshipsof the records displayed. For example, the records may be graphicallyrepresented using scatter plots, bar charts, pie charts, or othergraphical formats. Axes, colors, sizes, shapes, and other graphicalcharacteristics may be used to graphically represent differentdimensions or categories (e.g. different columns of Table 1) of therecords. The records may be graphically displayed in their raw format orin aggregated format depending on user preferences. Users may choose todisplay all the records (e.g., rows of Table 1) of the dataset or aportion of the records. Similarly, users may choose to display all thedimensions (e.g., columns of Table 1) of the records or a subset of thedimensions.

Using a scatter plot as an example, the axes may represent thedimensions (e.g., columns of a table) and the data points may representthe records (e.g., rows of a table). Additional graphicalcharacteristics, such as color, size, shape, label, etc., may also beused to represent additional dimensions. The records (i.e., theinformation comprised within the records) may be displayed in raw (i.e.,un-aggregated) format or in aggregated format. If the records aredisplayed in raw form, then each data point in the scatter plotrepresents one record. If the records are displayed in aggregated form,then each data point represents at least one record aggregated together.

In order to allow more flexible visualization of the large dataset, inone embodiment, by default, initially all the records in the dataset aredisplayed, represented by the data points, with each data pointrepresenting at least one record. The users may then conduct visualinspections of the records easily and quickly in order to select thosedata points (i.e., records) of particular interest.

Once the multi-dimensional records are displayed graphically, at 110, auser may graphically select one or more records of interest. Since therecords are represented graphically, for example, as in a scatter plotwhere each data point represents at least one record, graphicallyselecting records of interest may be done by clicking on thecorresponding individual data points representing those records with amouse while holding down the control key or selecting a group of datapoints by holding down the left mouse button and dragging the mouse overthe group of data points of interest. Since each data point representsat least one multi-dimensional record, by selecting the data point, theuser in effect has caused the corresponding record(s) to be selected.Other methods of selecting one or more graphically displayed graphicalobjects may also be used, depending on the actual graphical formatemployed to display the dataset.

After the records (i.e., data points) of interest have been selected,the user may choose to export the selected records in aggregated orun-aggregated form. If the user chooses to export the selected recordsin aggregated form, then at 120, the user has the option of specifyingwhat type of aggregation is to be performed on the selected records, andhow the records are to be divided into groups for aggregation. Forexample, each dimension of the selected records may be aggregated thesame or differently.

The specific type of aggregation may vary depending on user preferences.For example, the user may choose from aggregation types such as sum (thesum of all selected records), count (the total number of selectedrecords), median (the median value among the selected records), minimum(the minimum value among the selected records), maximum (the maximumvalue among the selected records), mean (the mean value of among theselected records), count greater than 0 (the total number of selectedrecords whose value is greater than 0), etc.

At 130, the selected records may be aggregated based on the user'saggregation specification. At 140, the aggregated records may beexported in a variety of format. The term “export” as used here meansany method of distinguishing the selected records from the unselectedrecords. For example, the selected records may be exported into a table,a spread sheet, a database, etc., depending on user preferences. Theselected records may even be left in place among the unselected records,with an indicator, such as a flag, indicating to the user which recordis selected and which record is not selected.

Alternatively, if the user chooses to export the selected records inun-aggregated or raw form, then no aggregation is needed. At 150, theselected records may be exported in their native/raw form, again in avariety of formats, such as into a table, a spread sheet, a database,etc., depending on user preferences. Thereafter, the user may focus onthe selected and exported subset of records for further analysis.

Regardless of whether the user chooses to export the selected records inaggregated or un-aggregated form, the selected records may be exportedwith all of their dimensions or a subset of dimensions. In the exampleshown in Table 1, the user may choose to export all the columns shown inTable 1 for the selected records, or select only a subset of the columnsto be exported for the selected records.

As will be understood, 100, 110, 120, 130, 140, and 150 may beimplemented as a software program. For example, an existing graphicallibrary, such as OpenGL or Java 3D, may be utilized in displaying thedata points in various graphical formats and providing the necessarygraphical and image functionalities. Data structures such as arrays orsets may be used to represent the records in the large dataset as wellas the selected subsets. For example, a new array or set may be used torepresent each subset of selected data points and/or records.

In addition, the software program may provide a user interface thatenables the users to interact with the graphically displayed recordsand/or to specify whether to export the selected records in aggregatedor un-aggregated form, and if the records are to be exported inaggregated form, what type of aggregation is to be performed. The actualdesign and implementation of such a user interface often depends on userand product design preferences. The layout of the user interface maytake into consideration the functionalities of the software as well asfactors such as easy of use, aesthetics, robustness, etc. For example, amenu may list all the available types of aggregations and the users maychoose a specific type of aggregation to be performed on the selectedsubset of records from the menu.

It may be helpful to further illustrate FIG. 1 with a specific example.The following Table 2 is a sample representation of a large datasetcomprising millions of multi-dimensional records. To simplify thedescription, only a small portion of the records are actually shown inTable 2.

TABLE 2 Geographical Monthly Monthly Record ID Age Gender LocationIncome Spending 0,000,001 38 M CT 2,750 1,200 0,000,002 29 F CA 7,7504,000 0,000,003 70 M SD 7,000 1,000 . . . 0,023,962 48 M FL 9,000 4,0000,023,963 38 F FL 8,750 5,000 . . . 0,553,015 75 F NY 14,750 8,0000,553,016 42 M WA 8,000 5,300 0,553,017 28 M IL 6,750 4,000 0,553,018 68F KY 4,500 2,500 . . . 1,512,528 43 F CO 9,250 2,200 1,512,529 22 F NJ6,500 3,000 . . . 2,164,274 60 M TX 6,750 500 . . . 3,513,529 34 M TX6,500 5,500 3,513,530 8 F OR 11,500 5,000 3,513,531 50 M MA 12,250 7,000

Again, in the sample dataset shown Table 2, each row represents arecord, and each column represents a dimension within the records sothat each record comprises multiple dimensions. Each record represents acustomer and may be identified by a unique record ID, as shown in thefirst column. The second column shows the customers' age. The thirdcolumn shows the customers' gender. The fourth column shows thecustomers' geographical location in terms of which state the customersare located. The fifth column shows the customers' monthly income. Andthe sixth column shows the amount the customers spend in a month.

FIG. 2A illustrates the portion of records of the dataset shown in Table2 graphically represented using a scatter plot. In this example, thescatter plot is used by way of illustration. And to simplify thedescription, only a two-dimensional scatter plot is shown. In FIG. 2A,the x-axis corresponds to the “Age” column and the y-axis corresponds tothe “Monthly Income” column of Table 2. The records are displayed inun-aggregated form. Thus, each data point in FIG. 2A provides anindication of a customer's age versus that customer's monthly income.

Alternatively, when desired, the user may choose to represent additionaltable columns (dimensions) in the plot. For example, the user may selectthe z-axis to correspond to the “Monthly Spending” column, making theplot into a three-dimensional scatter plot. Colors may be used torepresent the “Geographical Location” column, using a different color torepresent each state. Labels may be used to indicate the “Gender”column. And, so on. Other types of graphical formats may also be used tographically display the dataset based on user preferences.

In this example, the records are displayed in un-aggregated or raw form.Thus, each data point in the scatter plot represents one record.Alternatively, when desired, the user may choose to display the recordsin aggregated form, in which case each data point in the scatter plotmay represent multiple records.

Graphically representing the multi-dimensional records may help the useridentify records (i.e., data points) of interest or anomalous recordsquickly and easily. For example, the user may readily find that datapoint 210 is anomalous, since it is unlikely for an eight-year-old childto earn a monthly income of $11,500. If the user only had a textualdisplay of the records to work with, the user would have to go throughthe entire dataset, checking thousands, even millions of rows of data tolocate anomalous data values. And even then, it would be very easy tooverlook some anomalous data values. The errors in such records may becaused by a number of reasons, such as software bugs, erroneous inputs,etc. The user may choose to discard these anomalous records beforeconducting further analysis.

The user may also select a subset of data points (i.e., records) ofparticular interest. The selected data points may or may not bespatially contiguous in the scatter plot. For example, the user mayselect data points 220, 221, 222, which are spatially closely located.The user may also select data point 230, which is spatially located in adifferent location. In other words, the user may select any data pointdisplayed in the scatter plot.

FIG. 2B illustrates the dataset shown in FIG. 2A with a selected subsetof data points, where each data point represents at least onemulti-dimensional record from the dataset. By way of illustrations, 10data points 250 are selected. To distinguish selected data points 250from unselected data points 260, in one embodiment, the selected datapoints 250 may be displayed in a different graphical form from theunselected data points 260. For example, the selected data points 250may be highlighted, displayed in a different color, shape, or size,marked with a special label, etc.

Once the data points have been graphically selected, the recordsrepresented by the selected data points may be exported in aggregated orun-aggregated form. For example, the records in Table 2 corresponding tothe selected data points may be identified. Table 3 below shows the 10rows (i.e., records) from Table 2 that correspond to the selected 10data points 250 shown in FIG. 2B.

TABLE 3 Customer Geographical Monthly Monthly ID Age Gender LocationIncome Spending 0,000,002 29 F CA $7,750 $4,000 0,000,003 70 M SD $7,000$1,000 0,023,962 48 M FL $9,000 $4,000 0,023,963 38 F FL $8,750 $5,0000,553,016 42 M WA $8,000 $5,300 0,553,017 28 M IL $6,750 $4,0001,512,528 43 F CO $9,250 $2,200 1,512,529 22 F NJ $6,500 $3,0002,164,274 60 M TX $6,750  $500 3,513,529 34 M TX $6,500 $5,500

If the user chooses to export the records in their un-aggregated or rawform, then the 10 rows in Table 3 may be exported as they are. Theactual format of the exported data may vary depending on userpreferences. For example, the exported data may be saved as a spreadsheet, into a file, into a database, etc.

On the other hand, if the user chooses to export the records inaggregated form, the user may specify what type of aggregation is to beperformed on the selected records. For example, the user may wish toknow the average age of the 10 selected customers. Thus, the user mayspecify to export the average value of the “Age” column, which, in thisexample, is 41.4 years old. The user may wish to know the number ofmales in the 10 selected customers. Thus, the user may specify to exportthe male count for the “Gender” column, which, in this example, is 6males. The user may wish to know the total number of different states inwhich the 10 selected customers are located. Thus, the user may specifyto export the state count for the “Geographical Location” column, which,in this example, is 8 different states. The user may wish to know themaximum monthly income among the 10 selected customers. Thus, the usermay specify to export the maximum value of the “Monthly Income” column,which, in this example, is $9,250. Or, the user may wish to know the sumof the monthly spending amounts of the 10 selected customers. Thus, theuser may specify to export sum for the “Monthly Spending” column, which,in this example, is $34,500. Table 4 shows the 10 selected recordsexported in aggregated form as described above.

TABLE 4 Gender Geographical Monthly Monthly Customer Age (male LocationIncome Spending ID (average) count) (state count) (maximum) (sum) N/A41.4 6 males 8 states $9,250 $34,500

The user may choose to export any type of aggregated value for theselected records. The user may specify the same type of aggregation forall dimensions (i.e., columns) or different types of aggregation foreach dimension (i.e., columns) of the selected records. In addition, theuser may choose to aggregate all selected records together, or dividethe selected records into groups for aggregations based on anyuser-specified criteria.

For example, the user may choose to divide the selected records based on“gender” and specify to aggregate all male customers together and allfemale customers together. In this case, the aggregation base is maleand female. Continuing with the above example, the average age for the 6male customers is 47, and the average age for the 4 female customers is33. The 6 male customers are from 5 different states, and the 4 femalecustomers are from 4 different states. The maximum monthly income forthe 6 male customers is $9,000, and the maximum monthly income for the 4female customers is $9,250. The sum of monthly spending for the 6 malecustomers is $20,300, and the sum of monthly spending for the 4 femalecustomers is $14,200. Table 5 shows the 10 selected records exported inaggregated form and aggregated based on gender.

TABLE 5 Geographical Monthly Monthly Customer Age Location IncomeSpending ID (average) Gender (state count) (maximum) (sum) N/A 47 M 5states $9,000 $20,300 N/A 33 F 4 states $9,250 $14,200

In one embodiment, in addition to the graphical representation of therecords as shown in FIGS. 2A and 2B, a user interface may be designedand implemented to help the user to specify the aggregationspecification, which includes the aggregation base and the aggregationstypes for the dimensions. The actual design and implementation of such auser interface often depends on user preferences and/or designrequirements. The layout of the user interface may take intoconsideration the functionalities of the software as well as factorssuch as easy of use, intuitiveness, aesthetics, robustness, etc.

FIG. 3 illustrates a sample user interface that enables users to specifyaggregation specification and exporting form. This particular example ofthe user interface has three parts. First, the user may enter anaggregation type 320 for each of the dimensions 310 of the selectedrecords. In this example, the user may enter the dimension name andaggregation type for that dimension in the appropriate fields 310, 320.In other examples, alternative types of user interface components, suchas pull-down menu, check box, etc., may also be employed to enable theuser to specify the necessary information.

Next, the user may enter an aggregation base 330. Again, alternativetypes of user interface components may be employed to implement thisfield. Finally, two buttons 340, 345 are provided for the user to choosewhich form of the selected records is to be exported. If the user wishesto export the selected records in un-aggregated form, then the user maysimply click button 340. On the other hand, if the user wishes to exportthe selected records in aggregated form, then the user may simply clickbutton 345. Alternative types of user interface components may beemployed to implement this field as well.

The method described above in FIG. 1 may be carried out, for example, ina programmed computing system. FIG. 4 is a simplified diagram of anetwork environment in which specific embodiments of the presentinvention may be implemented. The various aspects of the invention maybe practiced in a wide variety of network environments (represented bynetwork 412) including, for example, TCP/IP-based networks,telecommunications networks, wireless networks, etc. In addition, thecomputer program instructions with which embodiments of the inventionare implemented may be stored in any type of computer-readable media,and may be executed according to a variety of computing modelsincluding, for example, on a stand-alone computing device, or accordingto a distributed computing model in which various of the functionalitiesdescribed herein may be effected or employed at different locations.

According to various embodiments, the multi-dimensional records thatbelong to the large datasets may be stored in a database 414. Theexported selected records may also be stored in the same database 414,or the exported selected records may be saved into a file on the user'scomputer 402. Users may access the datasets via the network usingdifferent methods, such as from computers 402, 403 connected to thenetwork 412.

The software program implementing various embodiments may be executed onthe server 408. Alternatively, the software program may be executed onthe users' computers 402, 403. The graphical representation of therecords points may be displayed on the users' computer screens, and theusers may interact with the graphically represented records, such asdata points in a scatter plot, through the user interface provided bythe software program.

While this invention has been described in terms of several preferredembodiments, there are alterations, permutations, and various substituteequivalents, which fall within the scope of this invention. It shouldalso be noted that there are many alternative ways of implementing themethods and apparatuses of the present invention. It is thereforeintended that the following appended claims be interpreted as includingall such alterations, permutations, and various substitute equivalentsas fall within the true spirit and scope of the present invention.

1. A computer-implemented method of operating on records of adimensionally-modeled fact collection, comprising: receiving a graphicalselection of a subset of data points from a set of displayed datapoints, each displayed data point representing at least one record of adimensionally-modeled fact collection by being graphically displayedrelative to at least two axes of a display, each axis of the displayrepresenting a particular dimension, and each data point representingthe at least one record such that the position of the data pointrelative to each axis is indicative of the value of the at least onerecord at the dimension represented by said each axis; and exportinginformation associated with the selected subset of data points, whereinexporting information associated with the selected subset of data pointscomprises: in conjunction with the graphical selection of a subset ofdata points from a set of displayed data points, receiving anaggregation specification; aggregating a subset of records correspondingto the selected subset of data points in accordance with the aggregationspecification; and exporting the subset of records in aggregated form.2. The computer-implemented method, as recited in claim 1, wherein theaggregation specification comprises an aggregation base that defines atleast one group into which the records are divided for aggregation andat least one aggregation type.
 3. The computer-implemented method, asrecited in claim 2, wherein the at least one aggregation type is atleast one type selected from the group consisting of maximum, minimum,mean, sum, and count.
 4. The computer-implemented method, as recited inclaim 2, wherein aggregating a subset of records corresponding to theselected subset of data points in accordance with the aggregationspecification comprises aggregating each of the plurality of dimensionsof the subset of records based on the aggregation base and acorresponding aggregation type.
 5. The computer-implemented method, asrecited in claim 1, wherein exporting information associated with theselected subset of data points further comprises: exporting the subsetof records corresponding to the selected subset of data points inun-aggregated form.
 6. The computer-implemented method, as recited inclaim 1, further comprising: graphically distinguishing the selectedsubset of data points from unselected data points of the set of datapoints.
 7. The computer-implemented method, as recited in claim 1,further comprising: graphically representing the set of displayed datapoints.
 8. A computer program product comprising a computer-readablemedium having a plurality of computer program instructions storedtherein, which are operable to cause at least one computing device to,in order to operate on records of a dimensionally-modeled factcollection: receive a graphical selection of a subset of data pointsfrom a set of displayed data points, each displayed data pointrepresenting at least one record of a dimensionally-modeled factcollection by being graphically displayed relative to at least two axesof a display, each axis of the display representing a particulardimension, and each data point representing the at least one record suchthat the position of the data point relative to each axis is indicativeof the value of the at least one record at the dimension represented bysaid each axis; and export information associated with the selectedsubset of data points, wherein for exporting information associated withthe selected subset of data points, the computer program instructionsare further operable to cause the at least one computer device to:receive an aggregation specification in conjunction with the graphicalselection of a subset of data points from a set of displayed datapoints; aggregate a subset of records corresponding to the selectedsubset of data points in accordance with the aggregation specification;and export the subset of records in aggregated form.
 9. The computerprogram product, as recited in claim 8, wherein the aggregationspecification comprises an aggregation base that defines at least onegroup into which the records are divided for aggregation and at leastone aggregation type.
 10. The computer program product, as recited inclaim 9, wherein the at least one aggregation type is at least one typeselected from the group consisting of maximum, minimum, mean, sum, andcount.
 11. The computer program product, as recited in claim 9, whereinfor aggregating a subset of records corresponding to the selected subsetof data points in accordance with the aggregation specification, thecomputer program instructions are further operable to cause the at leastone computer device to aggregate each of the plurality of dimensions ofthe subset of records based on the aggregation base and a correspondingaggregation type.
 12. The computer program product, as recited in claim8, wherein for exporting information associated with the selected subsetof data points, the computer program instructions are further operableto cause the at least one computer device to: export the subset ofrecords corresponding to the selected subset of data points inun-aggregated form.
 13. The computer program product, as recited inclaim 8, wherein the computer program instructions are further operableto cause the at least one computer device to: graphically distinguishthe selected subset of data points from unselected data points of theset of data points.
 14. The computer program product, as recited inclaim 8, wherein the computer program instructions are further operableto cause the at least one computer device to: graphically represent theset of displayed data points.